INDEX FULL SCAN
Short Description
Retrieval of all rowids from an index when there is no start or stop key. Indexed values are scanned in ascending order.
Detailed Description​
If all the columns you need to access are in the supporting index, Oracle can use an INDEX FULL SCAN to retrieve the data. This can remove the need for a separate sort as the data is retrieved using the index values' order.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.